begin tran
declare @i int 
select @i = convert(int, var_data) 
from igs_parm with(updlock) where var_name = 'gv_upd_id'
exec sp_pos_recal_vip_pts '1218000012192', @i
select * from pos_vip_info where vip_no = '86000007050'
rollback tran

select * from pos_sales_hdr where vip_no = '86000007050'

 